package com.mashibing.test.mapper;

import com.mashibing.test.entity.MobileTransfer;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @author SNA
 * @date 2025/8/25
 * @Description 查询携号转网相关信息的Mapper
 **/
public interface MobileTransferMapper {

    @Select("select transfer_number, now_isp from mobile_transfer where is_transfer = 1 and is_delete = 0")
    List<MobileTransfer> findAllMobileTransfer();
}
